TIMESTAMP vs DATE Data Type by Van Nguyen

Author:Van Nguyen
Language: eng
Format: azw3, epub
Publisher: UNKNOWN
Published: 2016-12-03T08:00:00+00:00

The optional 'nlsparam' argument has the same purpose in this function as in the TO_CHAR function for date conversion

Example

SELECT

TO_TIMESTAMP ('16-Dec-04 16:13:13.123456', 'DD-Mon-RR HH24:MI:SS.FF')

FROM EMPLOYEE

Output

16-DEC-04 04.13.13.123456000 PM

DATE Data Type

DATE data type is used to store DATE and TIME information

For each DATE value, oracle stores the following information

YEAR

MONTH

DAY

HOUR

MINUTE

SECOND

You can specify a DATE value as a literal or you can convert a character or number value to a DATE value with the TO_DATE function

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.